Mysql and replication

Posted by Prem on February 8th, 2014 filed in General, mysql

Last week, we ran into an issue of mysql getting stuck in a replication.  Turned out, one of the transaction that failed in the master, failed in the slave with a different error.  That had halted the replication.

This is how we fixed it.

mysql -p

STOP SLAVE;
SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1;
START SLAVE;
Basically, skip the particular erroneous transaction.

Leave a Comment

You must be logged in to post a comment.